CREATE TABLE [EventTypes] (
	[ID] INT PRIMARY KEY,
	[Name] NVARCHAR(100) NOT NULL
);

GO

CREATE TABLE [Events] (
	[ID] INT PRIMARY KEY IDENTITY(1, 1),
	[EventTypeID] INT NOT NULL REFERENCES [EventTypes]([ID]),
	[EventTime] DATETIME NOT NULL DEFAULT(GETDATE()),
	[Message] NVARCHAR(MAX) NOT NULL
);

GO